package qst.com.bacK.mapper;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import qst.com.bacK.pojo.entity.Exam;

import java.sql.SQLException;
import java.util.List;

/**
 * Author:   msh
 * Date:     2024/10/10 上午12:09
 * Description:
 */
public interface ExamMapper {

    @Select("select * from exams where personnel_id = #{id}")
    List<Exam> findByTestPersonnel(Integer id) throws SQLException;

    @Select("select * from exams where id = #{id}")
    List<Exam> findById(@Param("id") Integer id) throws SQLException;

    void updateExam(Exam exam)throws SQLException;

    void saveExam(Exam exam) throws SQLException;
}
